SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[RutasInsertCommand]
(
	@ID numeric(10, 0),
	@RUTA varchar(150),
	@COMENTARIO varchar(300)
)
AS
	SET NOCOUNT OFF;
DECLARE @I NUMERIC(10,0) = (SELECT(ISNULL(MAX([RUTAS].ID),0))+1 FROM [RUTAS]);
	
INSERT INTO [RUTAS] ([ID], [RUTA], [COMENTARIO]) VALUES (@I, @RUTA, @COMENTARIO);
	
SELECT ID, RUTA, COMENTARIO FROM RUTAS WHERE (ID = @I)
GO
